[QUIZ] Check your understanding of SQL - Part 2

Continue series What do you know about SQL? , part 2 continues with questions that revolve around basic knowledge in databases.

Question 1: In SQL, how to insert a new record into the "Persons" table?
1. INSERT INTO Persons VALUES ('Jimmy', 'Jackson')
2. INSERT VALUES ('Jimmy', 'Jackson') INTO Persons
3. INSERT ('Jimmy', 'Jackson') INTO Persons
Question 2: In SQL, how to insert the record "LastName" worth "Olsen" in the "Persons" table?
1. INSERT ('Olsen') INTO Persons (LastName)
2. INSERT INTO Persons ('Olsen') INTO LastName
3. INSERT INTO Persons (LastName) VALUES ('Olsen')
Question 3: How to change "Hansen" to "Nilsen" in the "LastName" column in the "Persons" table?
1. MODIFY Persons SET LastName = 'Nilsen' WHERE LastName = 'Hansen'
2. UPDATE Persons SET LastName = 'Nilsen' WHERE LastName = 'Hansen'
3. MODIFY Persons SET LastName = 'Hansen' INTO LastName = 'Nilsen
4. UPDATE Persons SET LastName = 'Hansen' INTO LastName = 'Nilsen'
Question 4: In SQL, how to delete the "Peter" record from the "FirstName" column in the "Persons" table?
1. DELETE FirstName = 'Peter' FROM Persons
2. DELETE ROW FirstName = 'Peter' FROM Persons
3. DELETE FROM Persons WHERE FirstName = 'Peter'
Question 5: In SQL, how to return the number of records in the "Persons" table?
1. SELECT COLUMNS (*) FROM Persons
2. SELECT COUNT (*) FROM Persons
3. SELECT LEN (*) FROM Persons
4. SELECT NO (*) FROM Persons
Question 6: Where is the most popular type of JOIN?
1. INNER JOIN
2. INSIDE JOIN
3. JOINED TABLE
4. JOINED
Question 7: Which operator is used to retrieve data in a range?
1. RANGE
2. BETWEEN
3. WITHIN
Question 8: The NOT NULL constraint does not accept a null value column.
1. It's correct
2. False
Question 9: Which clauses are used to find values according to certain patterns?
1. LIKE
2. GET
3. FROM
Question 10: Which SQL statement is used to create the table in the database?
1. CREATE DB
2. CREATE TABLE
3. CREATE DATABASE TAB
4. CREATE DATABASE TABLE

« PREV POST